CODEBOOK FOR obama_logs.csv

THIS DATA FILE IS USED BY visitor_logs_descriptives.R TO REPLICATE
ALL DESCRIPTIVE STATISTICS IN THE SUPPLEMENTAL INFORMATION THAT 
RELATE TO THE OBAMA VISITOR LOGS AND MATCHES MADE BETWEEN REGISTERED
LOBBYISTS AND VISITORS IN THOSE LOGS.

EACH ROW CORRESPONDS TO A VISIT FROM THE OBAMA WHITE HOUSE VISITOR
LOGS WHICH THE OBAMA ADMINISTRATION RELEASED DURING ITS TIME IN 
OFFICE.  THESE LOGS WERE OBTAINED DIRECTLY FROM THE OBAMA WHITE
HOUSE'S WEBSITE.  THIS DATA FILE CONTAINS ALL UNIQUE VISITS (I.E., ROWS) 
PROVIDED BY THE OBAMA ADMINISTRATION AND COLUMNS 3-30 ARE DRAWN DIRECTLY 
FROM THOSE VISITOR LOGS WITHOUT MODIFICATION 
BY THE AUTHOR.

VISITS ARE MATCHED WITH THE NAMES OF LOBBYISTS WHO WERE REGISTERED WITH
A CLIENT FOR THE TIME PERIOD CONCURRENT WITH THE VISIT (SEE SUPPLEMENTAL
INFORMATION C FOR MORE DETAILS ON MATCHING PROCEDURE).  THE VARIABLE
"APPT_START_DATE" WAS USED IN THE MATCHING PROCEDURE TO DETERMINE THE TIME
PERIOD IN WHICH EACH VISIT OCCURRED (AND THUS WHICH LDA REPORTS WERE
CONTEMPORANEOUS WITH EACH VISIT).

INFORMATION ABOUT VARIABLE VALUES (WHERE APPROPRIATE) ARE PROVIDED
IN PARENTHESES IN EACH VARIABLE DESCRIPTION.

WH_visit_id--UNIQUE NUMERIC VALUE FOR EACH VISIT (I.E., ROW)

WH_uniq_appt_id--UNIQUE NUMERIC VALUE FOR EACH APPOINTMENT.  APPOINTMENTS
ARE DEEMED UNIQUE IF ALL VISITOR LOG INFORMATION OTHER THAN THE VISITOR'S
NAME ARE UNIQUE (I.E., SAME MEETING DATE, TIME, LOCATION, VISITEE, ETC.)

NAMELAST--LAST NAME OF THE WHITE HOUSE VISITOR

NAMEFIRST--FIRST NAME OF THE WHITE HOUSE VISITOR

NAMEMID--MIDDLE NAME/INITIAL OF THE WHITE HOUSE VISITOR

UIN--UNIQUE IDENTIFICATION NUMBER.  NOTE: UINs ARE DUPLICATED OVER TIME, HENCE
THE AUTHOR'S ASSIGNMENT OF UNIQUE NUMERIC VALUES FOR EACH APPOINTMENT.

BDGNBR--THE NUMBER OF THE VISITOR ID BADGE ISSUED

Type of Access--TYPE OF ACCESS PROVIDED TO THE WHITE HOUSE VISITOR

TOA--THE VISITOR'S TIME OF ARRIVAL

POA--THE LOCATION WHERE THE VISITOR ARRIVED

TOD--THE VISITOR'S TIME OF DEPARTURE

POD--THE LOCATION WHERE THE VISITOR DEPARTED

APPT_MADE_DATE--THE DATE THE APPOINTMENT WAS MADE

APPT_START_DATE--THE DATE THE APPOINTMENT WAS SET TO START

APPT_END_DATE--THE DATE THE APPOINTMENT WAS SET TO END

APPT_CANCEL_DATE--THE DATE THE APPOINTMENT WAS CANCELLED, IF APPLICABLE; 
ANY CANCELLED APPOINTMENTS WERE REMOVED DURING THE VISIT AGGREGATION PROCESS

Total_People--THE NUMBER OF PEOPLE ASSOCIATED WITH THE APPOINTMENT

LAST_UPDATEDBY--THE INITIALS OF THE PERSON WHO LAST UPDATED THE ENTRY

POST--UNKNOWN FIELD PROVIDED IN ORIGINAL DATA (ALL VALUES ARE EITHER BLANK 
OR "WIN")

LastEntryDate--DATE THE VISIT WAS LAST UPDATED

TERMINAL_SUFFIX--THE INITIALS OF THE PERSON WHO LAST UPDATED THE ENTRY.  THIS FIELD
ALWAYS EITHER MATCHES THE VALUE IN "LAST_UPDATEDBY" OR IS BLANK.

visitee_namelast--THE LAST NAME OF THE VISITEE

visitee_namefirst--THE FIRST NAME OF THE VISITEE

MEETING_LOC--THE LOCATION OF THE MEETING ON THE WHITE HOUSE COMPLEX

MEETING_ROOM--THE ROOM FOR WHICH THE MEETING IS SCHEDULED

CALLER_NAME_LAST--THE LAST NAME OF THE PERSON WHO SUBMITTED THE WAVES REQUEST

CALLER_NAME_FIRST--THE FIRST NAME OF THE PERSON WHO SUBMITTED THE WAVES REQUEST

CALLER_ROOM--THE ROOM LOCATION OF THE PERSON SUBMITTED THE WAVES REQUEST

Description--A DESCRIPTION OF THE MEETING SCHEDULED.  PLEASE NOTE: AS DISCUSSED
IN THE SUPPLEMENTAL INFORMATION, THIS FIELD WAS USED INFREQUENTLY BY WHITE HOUSE
PERSONNEL AND SELDOM INCLUDED DETAILED INFORMATION ABOUT THE NATURE OF THE MEETING

RELEASE_DATE--DATE THE WHITE HOUSE RELEASED THE VISITOR LOG ENTRY

Lobbyist_id--ALPHANUMERIC ID NUMBER ASSIGNED BY THE CENTER FOR RESPONSIVE
POLITICS TO THE LOBBYIST WHOSE NAME MATCHES WITH THAT OF THE WHITE HOUSE 
VISITOR

Lobbyist--NAME OF THE LOBBYIST WHICH MATCHES WITH THAT OF THE WHITE HOUSE 
VISITOR.  NOTE: THESE ARE THE STANDARDIZED NAMES DRAWN FROM THE CENTER
FOR RESPONSIVE POLITICS, WHICH CURATES THE NAMES OF LOBBYISTS LISTED
ON LOBBYING DISCLOSURE ACT REPORTS.  THESE ARE THE NAMES THAT THE AUTHOR
USED TO MATCH WITH THE NAMES OF WHITE HOUSE VISITORS.

visitor_edit_distance--DAMERAU-LEVENSHTEIN DISTANCE THE STRING OF THE FIRST 
AND LAST NAME OF THE WHITE HOUSE VISITOR AND FIRST AND LAST NAME OF THE 
LOBBYIST TO WHICH THEY ARE MATCHED (0, 1, 2, OR 3)

visitee_known--WHETHER THE VISITEE, I.E., AUTHORITY, IS THE PRESIDENT, VICE-
PRESIDENT, FIRST LADY, OR THE NAME OF A STAFFER WHOSE SALARY INFORMATION
IS REPORTED BY THE WHITE HOUSE FOR WHO STAFFERS OR THE OFFICE OF PERSONNEL 
MANAGEMENT FOR NON-WHO STAFFERS IN EOP (1) OR NOT (0)

visitee_POTUS--WHETHER THE VISITEE IS THE PRESIDENT (1) OR NOT (0)

visitee_VPOTUS--WHETHER THE VISITEE IS THE VICE-PRESIDENT (1) OR NOT (0)

visitee_FLOTUS--WHETHER THE VISITEE IS THE FIRST LADY (1) OR NOT (0)

visitee_POTUSFLOTUS--WHETHER THE VISITEE IS THE PRESIDENT AND THE FIRST LADY
TOGETHER (1) OR NOT (0)

visitee_salary_quart--THE ANNUAL SALARY OF THE VISITEE AS REPORTED BY
THE WHITE HOUSE FOR WHO STAFFERS OR THE OFFICE OF PERSONNEL MANAGEMENT 
FOR NON-WHO STAFFERS IN EOP